﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using pbvs.Models;
using pbvs.Models.ViewModels;
using pbvs.Calculations;

namespace pbvs.Data
{
    public class ReportQuery
    {
		//public static IList<ValuationReport> GetValuations(int valuationId)
		//{
		//    using (PbvsContext db = new PbvsContext())
		//    {
		//        return (from req in db.Requests.Include("Client")
		//                where req.Id == valuationId
		//                let val = new Valuation(req)
		//                select new ValuationReport()
		//                           {
		//                               CreatedDate = req.CreatedDt, 
		//                               FirstName = req.Client.FirstName, 
		//                               LastName = req.Client.LastName, 
		//                               Company = req.Client.CompanyName, 
		//                               Address = req.Client.Address, 
		//                               Address2 = req.Client.Address2, 
		//                               City = req.Client.City, 
		//                               State = req.Client.State, 
		//                               Zip = req.Client.State, 
		//                               ParticipantFirstName = req.ParticipantFirstName, 
		//                               ParticipantLastName = req.ParticipantLastName,
		//                               SurvivorFirstName = req.SurvivorFirstName,
		//                               SurvivorLastName = req.SurvivorLastName,
		//                               Gender = req.Gender, 
		//                               ValuationDate = req.ValuationDate, 
		//                               PresentValueAtProjectedDate = val.PresentValueAtProjectedDate, 
		//                               MaritalPortionOfPresentValue = val.MaritalPortionOfPresentValue
		//                           }).ToList();
		//    }
		//}
    }
}